Skip to main content Skip to complementary content

Prerequisites

The following section describes the prerequisites for working with the Qlik Replicate SAP ODP endpoint.

ODP API

The SAP ODP endpoint uses ODP API 2.0 which is available from the following SAP basis levels and above:

  • PI_BASIS 730 SP 14 (part of SAP NetWeaver 7.30 SP 14)

  • PI_BASIS 731 SP 16 (part of SAP NetWeaver 7.03 SP 16 and 7.31 SP 16)

  • PI_BASIS 740 SP 11 (part of SAP NetWeaver 7.40 SP 11)

  • SAP_BW 750 SP 0 (incl. former PI_BASIS packages)

Information noteSAP_BASIS and PI_BASIS are interchangeable. In newer systems, the component name is SAP_BASIS.

For more information, see SAP Note 1931427.

For information on how to release extractors so that they are available for the ODP API, see SAP Note 2232584.

SAP Java Connector

To work with the SAP ODP endpoint, you need to install SAP Java Connector on the Replicate server.

Installing the SAP Java Connector on Replicate for Windows

To install the SAP Java Connector:

  1. Download the SAP Java Connector 3.x (64-bit) for Windows from the SAP Support Portal.

    To find out the exact SAP Java Connector version you need to support your SAP BW system, refer to the SAP BW Help.

    Information note

    The SAP Java Connector 3.1 running on Windows operating systems requires the Microsoft Visual Studio 2013 C/C++ runtime libraries to be installed on the system. See SAP Note 2786882 for details.

  2. Install the SAP Java Connector.

  3. Copy the Sapjco3.jar and Sapjco3.dll files from the SAP Java Connector installation folder to the following location under the Replicate installation directory:

    {REPLICATE_INSTALL_DIR}\endpoint_srv\endpoints\SAPOdp.

  4. Restart all of the Replicate services.
    Information noteIf SAP Extractor is already installed, move the Sapjco3.jar and Sapjco3.dll files from <REPLICATE_INSTALL_DIR>\endpoint_srv\externals to <REPLICATE_INSTALL_DIR>\endpoint_srv\endpoints\SAPOdp and restart all of the Replicate services.

Installing the SAP Java Connector on Replicate for Linux

To install the SAP Java Connector:

  1. Download the SAP Java Connector 3.x (64-bit) for Linux from the SAP Support Portal.

    To find out the exact SAP Java Connector version you need to support your SAP BW system, refer to the SAP BW Help.

  2. Unzip the file you downloaded to a folder of your choice.

    The folder should contain the Sapjco3.jar and libsapjco3.so files.

  3. Copy these files to the following location under the Replicate installation directory:

    <INSTALL_DIR>/endpoint_srv/endpoints/SAPOdp.

  4. Restart all of the Replicate services.

    Information note

    If SAP Extractor is already installed, copy the Sapjco3.jar and Sapjco3.dll files from <REPLICATE_INSTALL_DIR>/endpoint_srv/externals to the following locations:

    • <REPLICATE_INSTALL_DIR>/endpoint_srv/endpoints/SAPOdp
    • <REPLICATE_INSTALL_DIR>/endpoint_srv/endpoints/SAP

    Then restart all of the Replicate services as described in Replicate server procedures.

Information note

The SAP ODP endpoint will not be available for selection until the Java connector libraries have been installed and the Replicate service has been restarted.

STXL table support

To expose the table STXL for extraction using the SAP ODP endpoint, a custom extractor needs to be created in transaction RSO2 in SAP GUI. This extractor can then be called by the SAP ODP endpoint.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!